-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `DataBasreTables`
--

CREATE TABLE IF NOT EXISTS `DataBasreTables` (
  `TableName` text NOT NULL,
  `TableUse` text NOT NULL,
  `TableUserQuery` text NOT NULL,
  `TableLevel` text NOT NULL,
  `TableDescription` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DataBasreTables`
--

INSERT INTO `DataBasreTables` (`TableName`, `TableUse`, `TableUserQuery`, `TableLevel`, `TableDescription`) VALUES
('AdminExpPondNames', 'FALSE', 'FALSE', 'S', ''),
('AdminExpPonds', 'FALSE', 'FALSE', 'S', ''),
('AdminGlossary', 'FALSE', 'FALSE', 'G', 'Technical glossary'),
('AdminPICI', 'FALSE', 'FALSE', 'S', ''),
('AdminResMethods', 'FALSE', 'FALSE', 'G', 'Analytical methods handbook'),
('AdminStudies', 'FALSE', 'FALSE', 'G', ''),
('CodesManag', 'TRUE', 'FALSE', 'G', 'Management codes'),
('CodesPlank', 'TRUE', 'FALSE', 'G', 'Plankton codes'),
('CodesSite', 'TRUE', 'FALSE', 'G', 'Site codes'),
('CodesSolar', 'FALSE', 'FALSE', 'G', 'Solar codes'),
('CodesWind', 'TRUE', 'FALSE', 'G', 'Wind codes'),
('DataBaseTables', 'FALSE', 'FALSE', 'G', ''),
('DataFields', 'TRUE', 'FALSE', 'G', 'Data fields'),
('ExpListReport', 'FALSE', 'FALSE', 'E', ''),
('ExpTreatFishRU', 'TRUE', 'FALSE', 'T', 'Experiment treatment protocols'),
('ExpTreatSpecs', 'FALSE', 'FALSE', 'T', ''),
('ExpTreatTable', 'FALSE', 'FALSE', 'T', ''),
('FishMort', 'TRUE', 'FALSE', 'R', 'Fish mortality'),
('FishObserv', 'TRUE', 'FALSE', 'R', 'Fish observations'),
('FishSampling', 'TRUE', 'TRUE', 'R', 'Fish weight sampling'),
('PondAppAnal', 'TRUE', 'TRUE', 'T', 'Pond application materials'),
('PondAppRate', 'TRUE', 'TRUE', 'R', 'Pond application rates'),
('PondSoil', 'TRUE', 'TRUE', 'R', 'Pond soil analyses'),
('Publications', 'TRUE', 'FALSE', 'E', 'Publications'),
('PubTypes', 'FALSE', 'FALSE', 'E', ''),
('WatQualDO', 'TRUE', 'TRUE', 'R', 'Dissolved oxygen'),
('WatQualMinor', 'TRUE', 'TRUE', 'R', 'Minor water quality variables'),
('WatQualNP', 'TRUE', 'TRUE', 'R', 'Nitrogen and phosphorous'),
('WatQualPhAlk', 'TRUE', 'TRUE', 'R', 'Alkalinity and pH'),
('WatQualPlank', 'FALSE', 'FALSE', 'R', 'Plankton types and abundance'),
('WatQualPlankNew', 'FALSE', 'FALSE', 'R', 'Plankton types and abundance'),
('WatQualProd', 'TRUE', 'TRUE', 'R', 'Biological productivity'),
('WatQualSal', 'TRUE', 'TRUE', 'R', 'Water salinity'),
('WatQualTAN', 'TRUE', 'TRUE', 'R', 'Total ammonia nitrogen'),
('WatQualTemp', 'TRUE', 'TRUE', 'R', 'Water temperature'),
('WatQualTempMM', 'TRUE', 'FALSE', 'R', 'Water min-max temperature'),
('WatQuan', 'TRUE', 'TRUE', 'R', 'Water volume and flow'),
('WatQuanSpec', 'TRUE', 'FALSE', 'R', 'Fish rearing-unit design'),
('WeathHydro', 'TRUE', 'TRUE', 'E', 'Weather: rain, evaporation, humidity'),
('WeathSolar', 'TRUE', 'TRUE', 'E', 'Weather: solar radiation'),
('WeathTemp', 'TRUE', 'TRUE', 'E', 'Weather: air temperature'),
('WeathWind', 'TRUE', 'TRUE', 'E', 'Weather: wind speed');
